﻿CREATE TABLE [dbo].[t_CarInfo_OnLine] (
    [ID]            INT            NOT NULL,
    [ApplicantID]   INT            NOT NULL,
    [DealerID]      INT            NOT NULL,
    [VIN]           VARCHAR (20)   NULL,
    [Make]          VARCHAR (50)   NULL,
    [Model]         VARCHAR (50)   NULL,
    [Series]        VARCHAR (50)   NULL,
    [Body_Style]    VARCHAR (50)   NULL,
    [BodyStyleID]   INT            NULL,
    [SeriesID]      INT            NULL,
    [GroupNumber]   INT            NULL,
    [Year]          INT            NULL,
    [VIN_Year]      CHAR (1)       NULL,
    [Mileage]       INT            NULL,
    [Used]          BIT            NOT NULL,
    [Insurance]     NUMERIC (8, 2) NULL,
    [Trade]         INT            NULL,
    [CashDown]      INT            NULL,
    [CarInfoOther]  VARCHAR (1024) NULL,
    [SellPrice]     INT            NULL,
    [BookValue]     INT            NULL,
    [BookValueDesc] VARCHAR (128)  NULL,
    [Color]         VARCHAR (50)   NULL,
    [Tag]           VARCHAR (50)   NULL,
    [Doors]         TINYINT        NULL,
    [Promo]         BIT            NULL,
    [DealerTrackID] INT            NULL,
    [DealerFax]     VARCHAR (11)   NULL
);

